package com.sc.mapper.patrol;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.sc.domain.patrol.PatrolRecords;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

import java.util.List;

/*
 * 巡检记录
 * @author: Zuiliu
 * 实现：BaseMapper接口。
 * */
@Mapper
public interface PatrolRecordsMapper extends BaseMapper<PatrolRecords> {


    @Select("SELECT * FROM Zuiliu_patrol_records")
    List<PatrolRecords> selectAll();

    @Select("SELECT * FROM Zuiliu_patrol_records WHERE record_id = #{taskName}")
    PatrolRecords getByRecordId(@Param("taskName") String taskName);
}
